Smart Studies - 9th Class (Computer Science), Lesson No. 2, MS Excel Part-II

Welcome to SmartStudies.in! You visited this page for the first time.
Click Here to See Full Stats of Your Vists to SmartStudies.in

ਵਿੱਦਿਆ ਵਿਚਾਰੀ ਤਾਂ ਪਰ-ਉਪਕਾਰੀ।

ਨਕਲ ਕਰਨਾ ਪਾਪ ਹੈ।

ਵਿੱਦਿਆ ਮਨੁੱਖ ਦਾ ਤੀਸਰਾ ਨੇਤਰ ਹੈ।

ਨਕਲ ਆਤਮ-ਹੱਤਿਆ ਹੁੰਦੀ ਹੈ।

ਚਰਿੱਤਰ ਜੀਵਨ ਦੀ ਸ਼ਾਨ ਹੁੰਦੀ ਹੈ।

ਰੱਬ ਦੇ ਸਤਿਕਾਰ ਤੋਂ ਬਾਅਦ ਸਮੇਂ ਦਾ ਸਤਿਕਾਰ ਜ਼ਰੂਰੀ ਹੈ।

ਬੱਚਿਓ ਮਿਹਨਤ ਕਰਦੇ ਜਾਵੋ, ਮੰਜ਼ਿਲ ਵੱਲ ਪੱਬ ਧਰਦੇ ਜਾਵੋ।

Computer Science -> Solved Exercise -> Class - 9th, Lesson No. 2 (MS Excel Part-II)

CHAPTER - 2
MS EXCEL PART-II

Exercise

Points To Remember: --

A chart is a tool in MS Excel that is used to communicate our data graphically.
PivotTables are very helpful tool when we have to deal with large and complex spreadsheets.
Data validation is a powerful feature that is used to set up certain rules to dictate what can be entered into a cell.
What-if analysis is a powerful tool to do some complex calculations like calculating an unknown value.
The goal seek function is a part of what-if analysis tool set.
In Excel we can split the worksheet window into separate panes.
Excel automatically adds a black horizontal line to indicate that the top row is frozen.
Excel has an excellent feature to hide the selected rows, columns, and sheets.

Punjabi Font Converter

Click here to convert Punjabi Text Font from Anmollipi Font to Asees and Vice-Versa.

Punjabi Typing Tutor

Click here to learn Punjabi Typing in Anmollipi Font in an easier way.

English to Punjabi Converter

You can type Punjab using English Alphbets and Text will automatically be converted to Punjabi Text.

Class-room Time-Table Builder

This link can be used to create Class-Room Time-Table in an easiest way.

Smart Studies

Disclaimer:- Smart Studies is an online common resource of educational contents related to Computer Science based on Sylabus and Books based on P.S.E.B. Mohali, Candhigarh (Punjab). The structure of the project allows anyone with an Internet connection to read its content but we cannot guarantee the validity of the information found here and doesn't hold any responsibility. That is not to say that you will not find valuable and accurate information in Smart Studies much of the time you will.